Overview
Brought to you by YData
Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 500000 |
| Missing cells | 2252884 |
| Missing cells (%) | 18.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 616.5 MiB |
| Average record size in memory | 1.3 KiB |
Variable types
| Numeric | 4 |
|---|---|
| Categorical | 10 |
| Text | 4 |
| DateTime | 6 |
question_language has constant value "eng" | Constant |
question_user_type has constant value "farmer" | Constant |
response_user_type has constant value "farmer" | Constant |
question_id is highly overall correlated with question_user_id and 2 other fields | High correlation |
question_user_country_code is highly overall correlated with response_user_country_code | High correlation |
question_user_id is highly overall correlated with question_id and 1 other fields | High correlation |
response_id is highly overall correlated with question_id and 2 other fields | High correlation |
response_user_country_code is highly overall correlated with question_user_country_code | High correlation |
response_user_id is highly overall correlated with question_id and 1 other fields | High correlation |
response_language is highly imbalanced (88.8%) | Imbalance |
question_topic has 67186 (13.4%) missing values | Missing |
response_topic has 328854 (65.8%) missing values | Missing |
question_user_gender has 480094 (96.0%) missing values | Missing |
question_user_dob has 462710 (92.5%) missing values | Missing |
response_user_gender has 466152 (93.2%) missing values | Missing |
response_user_dob has 447888 (89.6%) missing values | Missing |
Reproduction
| Analysis started | 2025-11-06 14:26:33.238249 |
|---|---|
| Analysis finished | 2025-11-06 14:27:54.582144 |
| Duration | 1 minute and 21.34 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
question_id
Real number (ℝ)
High correlation
| Distinct | 428151 |
|---|---|
| Distinct (%) | 85.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27264997 |
| Minimum | 3849153 |
|---|---|
| Maximum | 59254650 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 MiB |
Quantile statistics
| Minimum | 3849153 |
|---|---|
| 5-th percentile | 6469463.8 |
| Q1 | 14135594 |
| median | 23611586 |
| Q3 | 40509218 |
| 95-th percentile | 56091867 |
| Maximum | 59254650 |
| Range | 55405497 |
| Interquartile range (IQR) | 26373624 |
Descriptive statistics
| Standard deviation | 15686339 |
|---|---|
| Coefficient of variation (CV) | 0.57532881 |
| Kurtosis | -1.0098993 |
| Mean | 27264997 |
| Median Absolute Deviation (MAD) | 11914470 |
| Skewness | 0.4396718 |
| Sum | 1.3632499 × 1013 |
| Variance | 2.4606122 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 56318162 | 136 | < 0.1% |
| 59076944 | 90 | < 0.1% |
| 43001179 | 83 | < 0.1% |
| 42820499 | 83 | < 0.1% |
| 59013285 | 81 | < 0.1% |
| 51577343 | 77 | < 0.1% |
| 31613688 | 66 | < 0.1% |
| 59087188 | 63 | < 0.1% |
| 58689878 | 50 | < 0.1% |
| 42634493 | 47 | < 0.1% |
| Other values (428141) | 499224 |
| Value | Count | Frequency (%) |
| 3849153 | 1 | |
| 3849275 | 1 | |
| 3849894 | 1 | |
| 3851330 | 1 | |
| 3851563 | 1 | |
| 3852433 | 1 | |
| 3852458 | 1 | |
| 3852789 | 1 | |
| 3853271 | 2 | |
| 3853305 | 1 |
| Value | Count | Frequency (%) |
| 59254650 | 1 | |
| 59254196 | 1 | |
| 59254047 | 1 | |
| 59253961 | 1 | |
| 59253791 | 1 | |
| 59253766 | 1 | |
| 59253374 | 1 | |
| 59253116 | 1 | |
| 59253035 | 1 | |
| 59252297 | 1 |
question_user_id
Real number (ℝ)
High correlation
| Distinct | 186897 |
|---|---|
| Distinct (%) | 37.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1561144.6 |
| Minimum | 7 |
|---|---|
| Maximum | 3826307 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 MiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 159020 |
| Q1 | 868627 |
| median | 1337141 |
| Q3 | 2217046 |
| 95-th percentile | 3363425 |
| Maximum | 3826307 |
| Range | 3826300 |
| Interquartile range (IQR) | 1348419 |
Descriptive statistics
| Standard deviation | 970567.66 |
|---|---|
| Coefficient of variation (CV) | 0.62170261 |
| Kurtosis | -0.71110304 |
| Mean | 1561144.6 |
| Median Absolute Deviation (MAD) | 633650 |
| Skewness | 0.49109575 |
| Sum | 7.8057229 × 1011 |
| Variance | 9.4200157 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 730226 | 978 | 0.2% |
| 3413249 | 861 | 0.2% |
| 3199006 | 797 | 0.2% |
| 853100 | 570 | 0.1% |
| 1061058 | 554 | 0.1% |
| 1206146 | 425 | 0.1% |
| 679197 | 415 | 0.1% |
| 607370 | 396 | 0.1% |
| 3065420 | 386 | 0.1% |
| 793767 | 383 | 0.1% |
| Other values (186887) | 494235 |
| Value | Count | Frequency (%) |
| 7 | 1 | < 0.1% |
| 19 | 2 | < 0.1% |
| 20 | 2 | < 0.1% |
| 26 | 1 | < 0.1% |
| 29 | 5 | |
| 88 | 5 | |
| 95 | 1 | < 0.1% |
| 122 | 2 | < 0.1% |
| 161 | 1 | < 0.1% |
| 173 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3826307 | 1 | < 0.1% |
| 3824546 | 2 | |
| 3824032 | 1 | < 0.1% |
| 3824014 | 1 | < 0.1% |
| 3822981 | 1 | < 0.1% |
| 3819473 | 1 | < 0.1% |
| 3818059 | 1 | < 0.1% |
| 3815627 | 1 | < 0.1% |
| 3814568 | 1 | < 0.1% |
| 3812531 | 4 |
question_language
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 32.4 MiB |
| eng |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | eng |
|---|---|
| 2nd row | eng |
| 3rd row | eng |
| 4th row | eng |
| 5th row | eng |
Common Values
| Value | Count | Frequency (%) |
| eng | 500000 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| eng | 500000 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 500000 | |
| n | 500000 | |
| g | 500000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1500000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 500000 | |
| n | 500000 | |
| g | 500000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1500000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 500000 | |
| n | 500000 | |
| g | 500000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1500000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 500000 | |
| n | 500000 | |
| g | 500000 |
question_content
Text
| Distinct | 416521 |
|---|---|
| Distinct (%) | 83.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 59.4 MiB |
Length
| Max length | 626 |
|---|---|
| Median length | 387 |
| Mean length | 59.075224 |
| Min length | 8 |
Unique
| Unique | 358953 ? |
|---|---|
| Unique (%) | 71.8% |
Sample
| 1st row | Q What vaccine can I use for my two weeks poultry |
|---|---|
| 2nd row | Do we have banana hybrid in Uganda |
| 3rd row | Q hoW TO PLANT CABBAGE |
| 4th row | Dononzio asks: my cow has aproblm it cann,t bleast feed their young one what can i do. Reply Q435 followed by your response. optout stop 6333 |
| 5th row | Q WHAT IS THE CORRECT AMOUNT OF A SIX ACRE LAND -FERTILIZER. |
| Value | Count | Frequency (%) |
| q | 217145 | 3.8% |
| to | 171446 | 3.0% |
| i | 168847 | 2.9% |
| is | 163195 | 2.8% |
| the | 157227 | 2.7% |
| of | 152917 | 2.7% |
| what | 129821 | 2.3% |
| in | 126044 | 2.2% |
| can | 117963 | 2.1% |
| how | 104824 | 1.8% |
| Other values (135304) | 4222701 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5379160 | ||
| e | 2246938 | 7.6% |
| a | 1950351 | 6.6% |
| t | 1726840 | 5.8% |
| o | 1650091 | 5.6% |
| i | 1488872 | 5.0% |
| n | 1383858 | 4.7% |
| s | 1315173 | 4.5% |
| r | 1085219 | 3.7% |
| h | 1038311 | 3.5% |
| Other values (129) | 10272799 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 29537612 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 5379160 | ||
| e | 2246938 | 7.6% |
| a | 1950351 | 6.6% |
| t | 1726840 | 5.8% |
| o | 1650091 | 5.6% |
| i | 1488872 | 5.0% |
| n | 1383858 | 4.7% |
| s | 1315173 | 4.5% |
| r | 1085219 | 3.7% |
| h | 1038311 | 3.5% |
| Other values (129) | 10272799 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 29537612 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 5379160 | ||
| e | 2246938 | 7.6% |
| a | 1950351 | 6.6% |
| t | 1726840 | 5.8% |
| o | 1650091 | 5.6% |
| i | 1488872 | 5.0% |
| n | 1383858 | 4.7% |
| s | 1315173 | 4.5% |
| r | 1085219 | 3.7% |
| h | 1038311 | 3.5% |
| Other values (129) | 10272799 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 29537612 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 5379160 | ||
| e | 2246938 | 7.6% |
| a | 1950351 | 6.6% |
| t | 1726840 | 5.8% |
| o | 1650091 | 5.6% |
| i | 1488872 | 5.0% |
| n | 1383858 | 4.7% |
| s | 1315173 | 4.5% |
| r | 1085219 | 3.7% |
| h | 1038311 | 3.5% |
| Other values (129) | 10272799 |
question_topic
Text
Missing
| Distinct | 147 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 67186 |
| Missing (%) | 13.4% |
| Memory size | 31.8 MiB |
Length
| Max length | 18 |
|---|---|
| Median length | 16 |
| Mean length | 5.7172758 |
| Min length | 3 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | poultry |
|---|---|
| 2nd row | banana |
| 3rd row | cabbage |
| 4th row | cattle |
| 5th row | cattle |
| Value | Count | Frequency (%) |
| cattle | 48109 | 11.1% |
| maize | 46682 | 10.8% |
| chicken | 43856 | 10.1% |
| plant | 39383 | 9.1% |
| tomato | 24043 | 5.6% |
| crop | 23050 | 5.3% |
| bean | 17287 | 4.0% |
| banana | 13485 | 3.1% |
| pig | 12413 | 2.9% |
| poultry | 11662 | 2.7% |
| Other values (137) | 152844 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 353038 | |
| t | 280987 | |
| e | 269351 | |
| c | 202093 | 8.2% |
| n | 179027 | 7.2% |
| o | 165524 | 6.7% |
| i | 156507 | 6.3% |
| l | 140340 | 5.7% |
| p | 123988 | 5.0% |
| m | 94476 | 3.8% |
| Other values (17) | 509186 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2474517 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 353038 | |
| t | 280987 | |
| e | 269351 | |
| c | 202093 | 8.2% |
| n | 179027 | 7.2% |
| o | 165524 | 6.7% |
| i | 156507 | 6.3% |
| l | 140340 | 5.7% |
| p | 123988 | 5.0% |
| m | 94476 | 3.8% |
| Other values (17) | 509186 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2474517 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 353038 | |
| t | 280987 | |
| e | 269351 | |
| c | 202093 | 8.2% |
| n | 179027 | 7.2% |
| o | 165524 | 6.7% |
| i | 156507 | 6.3% |
| l | 140340 | 5.7% |
| p | 123988 | 5.0% |
| m | 94476 | 3.8% |
| Other values (17) | 509186 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2474517 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 353038 | |
| t | 280987 | |
| e | 269351 | |
| c | 202093 | 8.2% |
| n | 179027 | 7.2% |
| o | 165524 | 6.7% |
| i | 156507 | 6.3% |
| l | 140340 | 5.7% |
| p | 123988 | 5.0% |
| m | 94476 | 3.8% |
| Other values (17) | 509186 |
question_sent
Date
| Distinct | 428132 |
|---|---|
| Distinct (%) | 85.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.6 MiB |
| Minimum | 2017-11-22 12:25:18+00:00 |
|---|---|
| Maximum | 2022-04-07 13:24:35.649166+00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
response_id
Real number (ℝ)
High correlation
| Distinct | 491737 |
|---|---|
| Distinct (%) | 98.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27465654 |
| Minimum | 3849219 |
|---|---|
| Maximum | 59257380 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 MiB |
Quantile statistics
| Minimum | 3849219 |
|---|---|
| 5-th percentile | 6603242.7 |
| Q1 | 14314404 |
| median | 23844892 |
| Q3 | 40725535 |
| 95-th percentile | 56302021 |
| Maximum | 59257380 |
| Range | 55408161 |
| Interquartile range (IQR) | 26411132 |
Descriptive statistics
| Standard deviation | 15711650 |
|---|---|
| Coefficient of variation (CV) | 0.57204719 |
| Kurtosis | -1.0220912 |
| Mean | 27465654 |
| Median Absolute Deviation (MAD) | 11996184 |
| Skewness | 0.43113889 |
| Sum | 1.3732827 × 1013 |
| Variance | 2.4685595 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 23509139 | 8 | < 0.1% |
| 19640035 | 8 | < 0.1% |
| 34384903 | 6 | < 0.1% |
| 42879592 | 6 | < 0.1% |
| 14162212 | 5 | < 0.1% |
| 14765080 | 5 | < 0.1% |
| 20386848 | 5 | < 0.1% |
| 16368368 | 5 | < 0.1% |
| 15379916 | 5 | < 0.1% |
| 22681354 | 5 | < 0.1% |
| Other values (491727) | 499942 |
| Value | Count | Frequency (%) |
| 3849219 | 1 | |
| 3850720 | 1 | |
| 3851694 | 1 | |
| 3852551 | 1 | |
| 3853336 | 1 | |
| 3853338 | 1 | |
| 3853616 | 1 | |
| 3853651 | 1 | |
| 3853782 | 1 | |
| 3853892 | 1 |
| Value | Count | Frequency (%) |
| 59257380 | 1 | |
| 59256603 | 1 | |
| 59255894 | 1 | |
| 59254746 | 1 | |
| 59254680 | 1 | |
| 59254610 | 1 | |
| 59254589 | 1 | |
| 59254451 | 1 | |
| 59254281 | 1 | |
| 59254274 | 1 |
response_user_id
Real number (ℝ)
High correlation
| Distinct | 154989 |
|---|---|
| Distinct (%) | 31.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1352732.7 |
| Minimum | 20 |
|---|---|
| Maximum | 3830610 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 MiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 96341 |
| Q1 | 651207 |
| median | 1171500 |
| Q3 | 1943918 |
| 95-th percentile | 3186456.4 |
| Maximum | 3830610 |
| Range | 3830590 |
| Interquartile range (IQR) | 1292711 |
Descriptive statistics
| Standard deviation | 926721.66 |
|---|---|
| Coefficient of variation (CV) | 0.68507373 |
| Kurtosis | -0.38490513 |
| Mean | 1352732.7 |
| Median Absolute Deviation (MAD) | 652556 |
| Skewness | 0.65113542 |
| Sum | 6.7636637 × 1011 |
| Variance | 8.5881304 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1364605 | 950 | 0.2% |
| 3413249 | 789 | 0.2% |
| 367428 | 552 | 0.1% |
| 1254217 | 450 | 0.1% |
| 3065420 | 448 | 0.1% |
| 202949 | 391 | 0.1% |
| 1149700 | 387 | 0.1% |
| 478338 | 384 | 0.1% |
| 1053962 | 379 | 0.1% |
| 1151861 | 357 | 0.1% |
| Other values (154979) | 494913 |
| Value | Count | Frequency (%) |
| 20 | 5 | < 0.1% |
| 26 | 2 | < 0.1% |
| 29 | 19 | |
| 32 | 2 | < 0.1% |
| 88 | 18 | |
| 92 | 3 | < 0.1% |
| 95 | 4 | < 0.1% |
| 120 | 2 | < 0.1% |
| 122 | 3 | < 0.1% |
| 142 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3830610 | 1 | < 0.1% |
| 3828425 | 4 | |
| 3812531 | 2 | |
| 3810614 | 1 | < 0.1% |
| 3798850 | 1 | < 0.1% |
| 3793014 | 1 | < 0.1% |
| 3775715 | 1 | < 0.1% |
| 3774477 | 4 | |
| 3768199 | 1 | < 0.1% |
| 3756523 | 1 | < 0.1% |
response_language
Categorical
Imbalance
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 32.4 MiB |
| eng | |
|---|---|
| swa | 16273 |
| lug | 1351 |
| nyn | 1316 |
| spa | 3 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | eng |
|---|---|
| 2nd row | eng |
| 3rd row | eng |
| 4th row | eng |
| 5th row | eng |
Common Values
| Value | Count | Frequency (%) |
| eng | 481057 | |
| swa | 16273 | 3.3% |
| lug | 1351 | 0.3% |
| nyn | 1316 | 0.3% |
| spa | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| eng | 481057 | |
| swa | 16273 | 3.3% |
| lug | 1351 | 0.3% |
| nyn | 1316 | 0.3% |
| spa | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 483689 | |
| g | 482408 | |
| e | 481057 | |
| s | 16276 | 1.1% |
| a | 16276 | 1.1% |
| w | 16273 | 1.1% |
| l | 1351 | 0.1% |
| u | 1351 | 0.1% |
| y | 1316 | 0.1% |
| p | 3 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1500000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 483689 | |
| g | 482408 | |
| e | 481057 | |
| s | 16276 | 1.1% |
| a | 16276 | 1.1% |
| w | 16273 | 1.1% |
| l | 1351 | 0.1% |
| u | 1351 | 0.1% |
| y | 1316 | 0.1% |
| p | 3 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1500000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 483689 | |
| g | 482408 | |
| e | 481057 | |
| s | 16276 | 1.1% |
| a | 16276 | 1.1% |
| w | 16273 | 1.1% |
| l | 1351 | 0.1% |
| u | 1351 | 0.1% |
| y | 1316 | 0.1% |
| p | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1500000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 483689 | |
| g | 482408 | |
| e | 481057 | |
| s | 16276 | 1.1% |
| a | 16276 | 1.1% |
| w | 16273 | 1.1% |
| l | 1351 | 0.1% |
| u | 1351 | 0.1% |
| y | 1316 | 0.1% |
| p | 3 | < 0.1% |
response_content
Text
| Distinct | 479494 |
|---|---|
| Distinct (%) | 95.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 54.1 MiB |
Length
| Max length | 935 |
|---|---|
| Median length | 703 |
| Mean length | 47.799758 |
| Min length | 1 |
Unique
| Unique | 467424 ? |
|---|---|
| Unique (%) | 93.5% |
Sample
| 1st row | Vaccinate against foul pox and coccidiosis |
|---|---|
| 2nd row | Q108 Yes In Bushenyi District |
| 3rd row | Q129 Just like sukumawiki, cabbages take the same process to plant. |
| 4th row | At fast provide bucket feeding and consult the veterinary. |
| 5th row | Q856 60KGS |
| Value | Count | Frequency (%) |
| the | 118077 | 2.8% |
| and | 89218 | 2.1% |
| of | 84517 | 2.0% |
| to | 79881 | 1.9% |
| is | 68289 | 1.6% |
| in | 59594 | 1.4% |
| it | 53705 | 1.3% |
| a | 44629 | 1.0% |
| you | 37964 | 0.9% |
| for | 33488 | 0.8% |
| Other values (284471) | 3591439 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3861932 | ||
| e | 1863114 | 7.8% |
| a | 1407386 | 5.9% |
| t | 1286787 | 5.4% |
| o | 1176913 | 4.9% |
| i | 1128189 | 4.7% |
| n | 1123922 | 4.7% |
| s | 1050551 | 4.4% |
| r | 982996 | 4.1% |
| l | 646189 | 2.7% |
| Other values (143) | 9371900 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 23899879 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3861932 | ||
| e | 1863114 | 7.8% |
| a | 1407386 | 5.9% |
| t | 1286787 | 5.4% |
| o | 1176913 | 4.9% |
| i | 1128189 | 4.7% |
| n | 1123922 | 4.7% |
| s | 1050551 | 4.4% |
| r | 982996 | 4.1% |
| l | 646189 | 2.7% |
| Other values (143) | 9371900 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 23899879 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3861932 | ||
| e | 1863114 | 7.8% |
| a | 1407386 | 5.9% |
| t | 1286787 | 5.4% |
| o | 1176913 | 4.9% |
| i | 1128189 | 4.7% |
| n | 1123922 | 4.7% |
| s | 1050551 | 4.4% |
| r | 982996 | 4.1% |
| l | 646189 | 2.7% |
| Other values (143) | 9371900 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 23899879 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3861932 | ||
| e | 1863114 | 7.8% |
| a | 1407386 | 5.9% |
| t | 1286787 | 5.4% |
| o | 1176913 | 4.9% |
| i | 1128189 | 4.7% |
| n | 1123922 | 4.7% |
| s | 1050551 | 4.4% |
| r | 982996 | 4.1% |
| l | 646189 | 2.7% |
| Other values (143) | 9371900 |
response_topic
Text
Missing
| Distinct | 148 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 328854 |
| Missing (%) | 65.8% |
| Memory size | 24.1 MiB |
Length
| Max length | 18 |
|---|---|
| Median length | 16 |
| Mean length | 5.6520748 |
| Min length | 3 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | plant |
|---|---|
| 2nd row | maize |
| 3rd row | wheat |
| 4th row | wheat |
| 5th row | plant |
| Value | Count | Frequency (%) |
| plant | 21003 | 12.3% |
| chicken | 15604 | 9.1% |
| cattle | 14587 | 8.5% |
| maize | 13128 | 7.7% |
| crop | 11732 | 6.9% |
| animal | 7933 | 4.6% |
| bean | 7068 | 4.1% |
| tomato | 5066 | 3.0% |
| banana | 4491 | 2.6% |
| potato | 3801 | 2.2% |
| Other values (138) | 66733 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 139190 | |
| e | 100536 | |
| t | 96685 | |
| n | 78002 | 8.1% |
| c | 76303 | 7.9% |
| l | 62330 | 6.4% |
| i | 59239 | 6.1% |
| o | 57711 | 6.0% |
| p | 55518 | 5.7% |
| r | 40145 | 4.2% |
| Other values (17) | 201671 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 967330 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 139190 | |
| e | 100536 | |
| t | 96685 | |
| n | 78002 | 8.1% |
| c | 76303 | 7.9% |
| l | 62330 | 6.4% |
| i | 59239 | 6.1% |
| o | 57711 | 6.0% |
| p | 55518 | 5.7% |
| r | 40145 | 4.2% |
| Other values (17) | 201671 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 967330 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 139190 | |
| e | 100536 | |
| t | 96685 | |
| n | 78002 | 8.1% |
| c | 76303 | 7.9% |
| l | 62330 | 6.4% |
| i | 59239 | 6.1% |
| o | 57711 | 6.0% |
| p | 55518 | 5.7% |
| r | 40145 | 4.2% |
| Other values (17) | 201671 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 967330 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 139190 | |
| e | 100536 | |
| t | 96685 | |
| n | 78002 | 8.1% |
| c | 76303 | 7.9% |
| l | 62330 | 6.4% |
| i | 59239 | 6.1% |
| o | 57711 | 6.0% |
| p | 55518 | 5.7% |
| r | 40145 | 4.2% |
| Other values (17) | 201671 |
response_sent
Date
| Distinct | 491721 |
|---|---|
| Distinct (%) | 98.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.6 MiB |
| Minimum | 2017-11-22 12:28:53+00:00 |
|---|---|
| Maximum | 2022-04-24 09:51:30.725947+00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
question_user_type
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 33.9 MiB |
| farmer |
|---|
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | farmer |
|---|---|
| 2nd row | farmer |
| 3rd row | farmer |
| 4th row | farmer |
| 5th row | farmer |
Common Values
| Value | Count | Frequency (%) |
| farmer | 500000 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| farmer | 500000 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 1000000 | |
| f | 500000 | |
| a | 500000 | |
| m | 500000 | |
| e | 500000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3000000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 1000000 | |
| f | 500000 | |
| a | 500000 | |
| m | 500000 | |
| e | 500000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3000000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 1000000 | |
| f | 500000 | |
| a | 500000 | |
| m | 500000 | |
| e | 500000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3000000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 1000000 | |
| f | 500000 | |
| a | 500000 | |
| m | 500000 | |
| e | 500000 |
question_user_status
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 33.4 MiB |
| live | |
|---|---|
| zombie | |
| destroyed | |
| blocked | 27274 |
Length
| Max length | 9 |
|---|---|
| Median length | 4 |
| Mean length | 5.062356 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | zombie |
|---|---|
| 2nd row | live |
| 3rd row | live |
| 4th row | zombie |
| 5th row | zombie |
Common Values
| Value | Count | Frequency (%) |
| live | 316883 | |
| zombie | 109953 | 22.0% |
| destroyed | 45890 | 9.2% |
| blocked | 27274 | 5.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| live | 316883 | |
| zombie | 109953 | 22.0% |
| destroyed | 45890 | 9.2% |
| blocked | 27274 | 5.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 545890 | |
| i | 426836 | |
| l | 344157 | |
| v | 316883 | |
| o | 183117 | 7.2% |
| b | 137227 | 5.4% |
| d | 119054 | 4.7% |
| z | 109953 | 4.3% |
| m | 109953 | 4.3% |
| s | 45890 | 1.8% |
| Other values (5) | 192218 | 7.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2531178 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 545890 | |
| i | 426836 | |
| l | 344157 | |
| v | 316883 | |
| o | 183117 | 7.2% |
| b | 137227 | 5.4% |
| d | 119054 | 4.7% |
| z | 109953 | 4.3% |
| m | 109953 | 4.3% |
| s | 45890 | 1.8% |
| Other values (5) | 192218 | 7.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2531178 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 545890 | |
| i | 426836 | |
| l | 344157 | |
| v | 316883 | |
| o | 183117 | 7.2% |
| b | 137227 | 5.4% |
| d | 119054 | 4.7% |
| z | 109953 | 4.3% |
| m | 109953 | 4.3% |
| s | 45890 | 1.8% |
| Other values (5) | 192218 | 7.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2531178 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 545890 | |
| i | 426836 | |
| l | 344157 | |
| v | 316883 | |
| o | 183117 | 7.2% |
| b | 137227 | 5.4% |
| d | 119054 | 4.7% |
| z | 109953 | 4.3% |
| m | 109953 | 4.3% |
| s | 45890 | 1.8% |
| Other values (5) | 192218 | 7.6% |
question_user_country_code
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.9 MiB |
| ke | |
|---|---|
| ug | |
| gb | 21 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ug |
|---|---|
| 2nd row | ug |
| 3rd row | ke |
| 4th row | ug |
| 5th row | ke |
Common Values
| Value | Count | Frequency (%) |
| ke | 313338 | |
| ug | 186641 | |
| gb | 21 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ke | 313338 | |
| ug | 186641 | |
| gb | 21 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| k | 313338 | |
| e | 313338 | |
| g | 186662 | |
| u | 186641 | |
| b | 21 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1000000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| k | 313338 | |
| e | 313338 | |
| g | 186662 | |
| u | 186641 | |
| b | 21 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1000000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| k | 313338 | |
| e | 313338 | |
| g | 186662 | |
| u | 186641 | |
| b | 21 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1000000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| k | 313338 | |
| e | 313338 | |
| g | 186662 | |
| u | 186641 | |
| b | 21 | < 0.1% |
question_user_gender
Categorical
Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 480094 |
| Missing (%) | 96.0% |
| Memory size | 34.3 MiB |
| male | |
|---|---|
| female |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.4021903 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | male |
|---|---|
| 2nd row | female |
| 3rd row | male |
| 4th row | male |
| 5th row | male |
Common Values
| Value | Count | Frequency (%) |
| male | 15903 | 3.2% |
| female | 4003 | 0.8% |
| (Missing) | 480094 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| male | 15903 | |
| female | 4003 | 20.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 23909 | |
| m | 19906 | |
| a | 19906 | |
| l | 19906 | |
| f | 4003 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87630 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 23909 | |
| m | 19906 | |
| a | 19906 | |
| l | 19906 | |
| f | 4003 | 4.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87630 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 23909 | |
| m | 19906 | |
| a | 19906 | |
| l | 19906 | |
| f | 4003 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87630 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 23909 | |
| m | 19906 | |
| a | 19906 | |
| l | 19906 | |
| f | 4003 | 4.6% |
question_user_dob
Date
Missing
| Distinct | 6936 |
|---|---|
| Distinct (%) | 18.6% |
| Missing | 462710 |
| Missing (%) | 92.5% |
| Memory size | 7.6 MiB |
| Minimum | 1917-12-07 00:00:00 |
|---|---|
| Maximum | 2020-08-27 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 185859 |
|---|---|
| Distinct (%) | 37.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.6 MiB |
| Minimum | 2014-11-27 16:15:53+00:00 |
|---|---|
| Maximum | 2022-03-26 11:57:31.241786+00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
response_user_type
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 33.9 MiB |
| farmer |
|---|
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | farmer |
|---|---|
| 2nd row | farmer |
| 3rd row | farmer |
| 4th row | farmer |
| 5th row | farmer |
Common Values
| Value | Count | Frequency (%) |
| farmer | 500000 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| farmer | 500000 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 1000000 | |
| f | 500000 | |
| a | 500000 | |
| m | 500000 | |
| e | 500000 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3000000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 1000000 | |
| f | 500000 | |
| a | 500000 | |
| m | 500000 | |
| e | 500000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3000000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 1000000 | |
| f | 500000 | |
| a | 500000 | |
| m | 500000 | |
| e | 500000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3000000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 1000000 | |
| f | 500000 | |
| a | 500000 | |
| m | 500000 | |
| e | 500000 |
response_user_status
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 33.4 MiB |
| live | |
|---|---|
| zombie | |
| destroyed | |
| blocked | 22528 |
Length
| Max length | 9 |
|---|---|
| Median length | 4 |
| Mean length | 5.081214 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | zombie |
|---|---|
| 2nd row | live |
| 3rd row | live |
| 4th row | zombie |
| 5th row | live |
Common Values
| Value | Count | Frequency (%) |
| live | 332948 | |
| zombie | 83199 | 16.6% |
| destroyed | 61325 | 12.3% |
| blocked | 22528 | 4.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| live | 332948 | |
| zombie | 83199 | 16.6% |
| destroyed | 61325 | 12.3% |
| blocked | 22528 | 4.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 561325 | |
| i | 416147 | |
| l | 355476 | |
| v | 332948 | |
| o | 167052 | 6.6% |
| d | 145178 | 5.7% |
| b | 105727 | 4.2% |
| z | 83199 | 3.3% |
| m | 83199 | 3.3% |
| s | 61325 | 2.4% |
| Other values (5) | 229031 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2540607 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 561325 | |
| i | 416147 | |
| l | 355476 | |
| v | 332948 | |
| o | 167052 | 6.6% |
| d | 145178 | 5.7% |
| b | 105727 | 4.2% |
| z | 83199 | 3.3% |
| m | 83199 | 3.3% |
| s | 61325 | 2.4% |
| Other values (5) | 229031 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2540607 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 561325 | |
| i | 416147 | |
| l | 355476 | |
| v | 332948 | |
| o | 167052 | 6.6% |
| d | 145178 | 5.7% |
| b | 105727 | 4.2% |
| z | 83199 | 3.3% |
| m | 83199 | 3.3% |
| s | 61325 | 2.4% |
| Other values (5) | 229031 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2540607 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 561325 | |
| i | 416147 | |
| l | 355476 | |
| v | 332948 | |
| o | 167052 | 6.6% |
| d | 145178 | 5.7% |
| b | 105727 | 4.2% |
| z | 83199 | 3.3% |
| m | 83199 | 3.3% |
| s | 61325 | 2.4% |
| Other values (5) | 229031 |
response_user_country_code
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.9 MiB |
| ke | |
|---|---|
| ug | |
| gb | 21 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ug |
|---|---|
| 2nd row | ug |
| 3rd row | ke |
| 4th row | ug |
| 5th row | ke |
Common Values
| Value | Count | Frequency (%) |
| ke | 313338 | |
| ug | 186641 | |
| gb | 21 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ke | 313338 | |
| ug | 186641 | |
| gb | 21 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| k | 313338 | |
| e | 313338 | |
| g | 186662 | |
| u | 186641 | |
| b | 21 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1000000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| k | 313338 | |
| e | 313338 | |
| g | 186662 | |
| u | 186641 | |
| b | 21 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1000000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| k | 313338 | |
| e | 313338 | |
| g | 186662 | |
| u | 186641 | |
| b | 21 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1000000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| k | 313338 | |
| e | 313338 | |
| g | 186662 | |
| u | 186641 | |
| b | 21 | < 0.1% |
response_user_gender
Categorical
Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 466152 |
| Missing (%) | 93.2% |
| Memory size | 34.2 MiB |
| male | |
|---|---|
| female |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.3092059 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | female |
|---|---|
| 2nd row | male |
| 3rd row | male |
| 4th row | female |
| 5th row | male |
Common Values
| Value | Count | Frequency (%) |
| male | 28615 | 5.7% |
| female | 5233 | 1.0% |
| (Missing) | 466152 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| male | 28615 | |
| female | 5233 | 15.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 39081 | |
| m | 33848 | |
| a | 33848 | |
| l | 33848 | |
| f | 5233 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 145858 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 39081 | |
| m | 33848 | |
| a | 33848 | |
| l | 33848 | |
| f | 5233 | 3.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 145858 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 39081 | |
| m | 33848 | |
| a | 33848 | |
| l | 33848 | |
| f | 5233 | 3.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 145858 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 39081 | |
| m | 33848 | |
| a | 33848 | |
| l | 33848 | |
| f | 5233 | 3.6% |
response_user_dob
Date
Missing
| Distinct | 8157 |
|---|---|
| Distinct (%) | 15.7% |
| Missing | 447888 |
| Missing (%) | 89.6% |
| Memory size | 7.6 MiB |
| Minimum | 1917-12-07 00:00:00 |
|---|---|
| Maximum | 2020-09-07 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 153536 |
|---|---|
| Distinct (%) | 30.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.6 MiB |
| Minimum | 2014-11-28 08:05:19+00:00 |
|---|---|
| Maximum | 2022-04-01 08:30:14.960459+00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Interactions
Correlations
| question_id | question_user_country_code | question_user_gender | question_user_id | question_user_status | response_id | response_language | response_user_country_code | response_user_gender | response_user_id | response_user_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| question_id | 1.000 | 0.166 | 0.112 | 0.662 | 0.282 | 0.992 | 0.021 | 0.166 | 0.070 | 0.625 | 0.254 |
| question_user_country_code | 0.166 | 1.000 | 0.008 | 0.157 | 0.212 | 0.167 | 0.293 | 1.000 | 0.025 | 0.170 | 0.193 |
| question_user_gender | 0.112 | 0.008 | 1.000 | 0.122 | 0.072 | 0.109 | 0.000 | 0.008 | 0.000 | 0.067 | 0.043 |
| question_user_id | 0.662 | 0.157 | 0.122 | 1.000 | 0.200 | 0.657 | 0.016 | 0.157 | 0.060 | 0.433 | 0.188 |
| question_user_status | 0.282 | 0.212 | 0.072 | 0.200 | 1.000 | 0.281 | 0.031 | 0.212 | 0.022 | 0.193 | 0.136 |
| response_id | 0.992 | 0.167 | 0.109 | 0.657 | 0.281 | 1.000 | 0.023 | 0.167 | 0.069 | 0.622 | 0.257 |
| response_language | 0.021 | 0.293 | 0.000 | 0.016 | 0.031 | 0.023 | 1.000 | 0.293 | 0.011 | 0.027 | 0.028 |
| response_user_country_code | 0.166 | 1.000 | 0.008 | 0.157 | 0.212 | 0.167 | 0.293 | 1.000 | 0.025 | 0.170 | 0.193 |
| response_user_gender | 0.070 | 0.025 | 0.000 | 0.060 | 0.022 | 0.069 | 0.011 | 0.025 | 1.000 | 0.131 | 0.042 |
| response_user_id | 0.625 | 0.170 | 0.067 | 0.433 | 0.193 | 0.622 | 0.027 | 0.170 | 0.131 | 1.000 | 0.170 |
| response_user_status | 0.254 | 0.193 | 0.043 | 0.188 | 0.136 | 0.257 | 0.028 | 0.193 | 0.042 | 0.170 | 1.000 |
Missing values
Sample
| question_id | question_user_id | question_language | question_content | question_topic | question_sent | response_id | response_user_id | response_language | response_content | response_topic | response_sent | question_user_type | question_user_status | question_user_country_code | question_user_gender | question_user_dob | question_user_created_at | response_user_type | response_user_status | response_user_country_code | response_user_gender | response_user_dob | response_user_created_at | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7125941 | 29239575 | 2341184 | eng | Q What vaccine can I use for my two weeks poultry | poultry | 2019-07-29 14:48:41.696704+00 | 29246834 | 1917051 | eng | Vaccinate against foul pox and coccidiosis | None | 2019-07-29 16:04:14.54143+00 | farmer | zombie | ug | None | None | 2019-07-29 14:45:56.686123+00 | farmer | zombie | ug | None | None | 2019-02-25 16:57:44.433512+00 |
| 2337096 | 12064070 | 1082751 | eng | Do we have banana hybrid in Uganda | banana | 2018-09-26 14:47:57.686568+00 | 12064864 | 757555 | eng | Q108 Yes In Bushenyi District | None | 2018-09-26 14:52:22.698027+00 | farmer | live | ug | None | None | 2018-08-20 09:45:55.096378+00 | farmer | live | ug | None | None | 2018-03-31 06:18:55.66669+00 |
| 1168002 | 8586012 | 1061566 | eng | Q hoW TO PLANT CABBAGE | cabbage | 2018-08-11 12:05:42.179556+00 | 8586256 | 472714 | eng | Q129 Just like sukumawiki, cabbages take the same process to plant. | plant | 2018-08-11 12:11:01.808037+00 | farmer | live | ke | None | None | 2018-08-11 12:03:23.067669+00 | farmer | live | ke | None | None | 2017-10-26 17:47:11+00 |
| 4705029 | 18949097 | 1041893 | eng | Dononzio asks: my cow has aproblm it cann,t bleast feed their young one what can i do. Reply Q435 followed by your response.\n\noptout stop 6333 | cattle | 2018-12-12 11:25:23.516055+00 | 19056212 | 1492749 | eng | At fast provide bucket feeding and consult the veterinary. | None | 2018-12-13 07:36:03.201454+00 | farmer | zombie | ug | None | None | 2018-08-07 09:45:11.23247+00 | farmer | zombie | ug | None | None | 2018-11-16 22:29:47.964895+00 |
| 6966053 | 28086743 | 2260122 | eng | Q WHAT IS THE CORRECT AMOUNT OF A SIX ACRE LAND -FERTILIZER. | None | 2019-07-07 12:59:54.864268+00 | 28087909 | 36254 | eng | Q856 60KGS | None | 2019-07-07 14:06:26.08581+00 | farmer | zombie | ke | None | None | 2019-07-07 12:56:09.701871+00 | farmer | live | ke | female | 1997-07-22 | 2015-11-16 17:13:12+00 |
| 6875319 | 27698080 | 804559 | eng | Q Other Than Fresian,jursey,borana Metion Other Names Of Cows You Know. | cattle | 2019-06-27 15:34:56.701268+00 | 27700018 | 2075087 | eng | Q6 Curns | None | 2019-06-27 15:41:43.699797+00 | farmer | live | ke | None | None | 2018-04-23 11:58:50.562182+00 | farmer | live | ke | None | None | 2019-04-30 09:24:16.294116+00 |
| 10265148 | 47545944 | 1682932 | eng | Q.Which is the most harmful disease in maize plants | maize | 2020-09-29 13:56:05.573754+00 | 47557418 | 2975907 | eng | Reply Q15~Wilthing of maize plants caused by stalkborer(worm),it kills the plant and finally no yield/harvest. Thank you. | maize | 2020-09-29 14:54:22.84647+00 | farmer | live | ke | None | None | 2018-12-11 11:55:31.454405+00 | farmer | live | ke | None | None | 2020-03-19 17:41:30.767385+00 |
| 4182699 | 17493270 | 1294911 | eng | Q, what cozes splitting ov bananas in there old stage ov development when it is ready for harvesting? | banana | 2018-12-01 07:41:57.789183+00 | 17498791 | 1072318 | eng | Q47 It Depends On Type Of Soil , | None | 2018-12-01 07:56:15.488265+00 | farmer | destroyed | ug | None | None | 2018-10-03 15:27:21.587963+00 | farmer | live | ug | None | None | 2018-08-15 17:41:07.330389+00 |
| 8926109 | 40228146 | 2918137 | eng | Q why are leguminous preferre for green manure? | None | 2020-04-13 07:47:52.876696+00 | 40233669 | 2520723 | eng | Q16 they prefer in green manure becouse green it decompose slowly in the farme | None | 2020-04-13 10:15:19.078848+00 | farmer | live | ke | None | None | 2020-02-26 08:58:02.430389+00 | farmer | live | ke | None | None | 2019-09-26 17:51:35.860522+00 |
| 3258067 | 14901360 | 1413665 | eng | WIC TYPE OV FERTILIZER IS ADVISABLE TO APLY IN BANANA PLANTATION? | banana | 2018-11-05 08:22:43.028284+00 | 14901715 | 751622 | eng | Q358, use farm yard manure | None | 2018-11-05 08:30:13.53201+00 | farmer | zombie | ug | None | None | 2018-10-31 19:21:57.323151+00 | farmer | live | ug | None | None | 2018-03-28 18:08:56.313601+00 |
| question_id | question_user_id | question_language | question_content | question_topic | question_sent | response_id | response_user_id | response_language | response_content | response_topic | response_sent | question_user_type | question_user_status | question_user_country_code | question_user_gender | question_user_dob | question_user_created_at | response_user_type | response_user_status | response_user_country_code | response_user_gender | response_user_dob | response_user_created_at | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6655834 | 26641766 | 1819939 | eng | Who can u cross breed chicken | chicken | 2019-06-01 05:25:12.808348+00 | 26657283 | 1816786 | eng | Q34 Aperson With A Good Breed | None | 2019-06-01 12:19:57.960275+00 | farmer | zombie | ug | None | None | 2019-01-11 07:40:36.222728+00 | farmer | destroyed | ug | None | None | 2019-01-10 08:02:15.875999+00 |
| 5035958 | 20054112 | 1724429 | eng | Diamethoade is used to treat cigar end rot in kales; cigar end rot is the rotting of kales stalks producing bad odours due to poor picking of the leaves. | kale | 2018-12-28 17:08:08.67508+00 | 20054894 | 1437652 | eng | Q130 so wot | None | 2018-12-28 17:25:31.020792+00 | farmer | live | ke | None | None | 2018-12-14 09:01:30.09489+00 | farmer | live | ke | None | None | 2018-11-08 14:01:34.442573+00 |
| 7879254 | 33330157 | 2596524 | eng | Q how can i solve a problem of tomato bright | tomato | 2019-10-21 08:48:50.462447+00 | 33332594 | 1204171 | eng | Q144 spray using ridomil | None | 2019-10-21 10:17:44.159335+00 | farmer | zombie | ug | None | None | 2019-10-21 08:21:35.444754+00 | farmer | live | ug | None | None | 2018-09-14 09:39:13.825308+00 |
| 1130391 | 8467873 | 71917 | eng | Which kind of trees that i as farmer can plant along the boundary, that may not affect my crops. | tree | 2018-08-09 13:38:18.483454+00 | 8530618 | 532089 | eng | Q117 THE TREES THAT U PLANT ALONG THE BOUNDARY IS SEVESEVE | tree | 2018-08-10 14:15:42.750104+00 | farmer | destroyed | ke | male | None | 2016-05-25 04:48:04+00 | farmer | live | ke | None | None | 2017-11-23 17:53:59+00 |
| 11329324 | 55685107 | 3048311 | eng | What is the price of Chick marsh? | chicken | 2021-04-22 17:25:33.779862+00 | 55731585 | 1814926 | eng | Q74 Acording to our place. 5kg=250%2C 10kg%3D500%2C 50kg%3D1200 and 90kg is 1850%2F%3D | None | 2021-04-23 12:17:13.031618+00 | farmer | live | ke | None | None | 2020-04-16 17:59:05.407561+00 | farmer | live | ke | None | None | 2019-01-09 17:23:36.86069+00 |
| 7637680 | 31892845 | 1074144 | eng | how is onions propagated? | onion | 2019-09-19 17:40:07.178611+00 | 31896831 | 1573372 | eng | By seed and later seedlings | None | 2019-09-19 17:54:18.607449+00 | farmer | zombie | ug | None | None | 2018-08-15 19:56:54.121329+00 | farmer | live | ug | None | None | 2018-11-30 13:07:10.180261+00 |
| 7450108 | 30813613 | 2300714 | eng | Weldon Q Give me types of grass good for dairy cows,good for protains,vitamins? | grass | 2019-08-29 16:32:09.003019+00 | 30813965 | 92215 | eng | Q147 Lucerne,brachiari,boma rodes,Napier grass,gloves, | napier-grass | 2019-08-29 16:34:08.091048+00 | farmer | live | ke | None | None | 2019-07-18 17:20:14.52606+00 | farmer | live | ke | male | 1990-01-15 | 2016-09-12 04:51:14+00 |
| 9618448 | 44186503 | 2155417 | eng | What crop can i grow and earn income within this holiday and tell me the possible methods to use ? | crop | 2020-07-03 17:48:33.54539+00 | 44346481 | 2047285 | eng | Q89 Cabbage | cabbage | 2020-07-07 16:55:05.879693+00 | farmer | live | ug | None | None | 2019-05-26 17:47:13.214765+00 | farmer | live | ug | None | None | 2019-04-16 11:49:35.598023+00 |
| 7761108 | 32482789 | 555688 | eng | Everline asks: Is there any way I can boost my flowering beans after a heavy downpour of hailstones??? Reply Q471 followed by your response. | bean | 2019-09-29 16:26:38.978063+00 | 32483333 | 2149257 | eng | Q8,use forliar fertilizer | None | 2019-09-29 16:30:47.754327+00 | farmer | zombie | ke | None | None | 2017-11-30 17:22:06+00 | farmer | destroyed | ke | None | None | 2019-05-23 17:29:12.86036+00 |
| 5649689 | 22267914 | 475244 | eng | HOW CAN I KEEP THEM FROM DENGERS. | None | 2019-03-06 04:40:04.794134+00 | 22275907 | 638307 | eng | Q185 by use of techinical know how makernizms to protect the may come problem. | None | 2019-03-06 09:27:56.944099+00 | farmer | destroyed | ug | None | None | 2017-10-28 10:20:48+00 | farmer | live | ug | None | None | 2018-01-23 17:52:20+00 |